Effective Inventory
The system calculates the inventory that is going to be used in the rest of the calculations in the following way:
Effective Inventory:
Inventory
- + Quantity on Purchase Order
- - Quantity on Sales Order
- + Quantity in Transfer In
- - Quantity in Transfer Out
Average Daily Sale
The Average Daily Sale is not calculated as in the method Average Usage. The value of the field Manual Estimated Daily Sales is used as Average Daily Sale.
If there are Planned Sales Demand records for the covered period:
- The system sums the quantity of the Planned Sales Demand records in the following way:
Average Daily Sale = Average Daily Sale * (No of Days – No of Planned Sales Demand Days) + Total Planned Sales Demand Quantity
Field of Replenishment Item Quantity record:
"Planned Sales Demand" = Total Planned Sales Demand Quantity
The field Adjusted Sales in Replenishment Item Quantity record:
Adjusted Sales = Corrected Quantity
The result of the above process is the Average Daily Sale.
Store Stock Cover (Days)
The system uses the Store Stock Cover Reqd.(Days) field unless the Replenishment Journal is to replenish a warehouse, i which case it uses the Warehouse Stock Cover Reqd.(Days) field. If the Warehouse Stock Cover Reqd.(Days) field is empty, the Store Stock Cover Reqd.(Days) field is used.
Stock Cover Days = Store Stock Cover Reqd.(Days)
-or-
Stock Cover Days = Warehouse Stock Cover Reqd.(Days)
Coverage Shortfall
The system calculates the shortfall of stock to be able to have enough stock for the number of days the sale needs to cover.
"Calc. Coverage Shortfall" := ROUND(((“Average Daily Sale” * “Stock Cover Days”) – "Effective Inventory") / “Average Daily Sale”,1,'>');